<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ page import="org.quartzweb.util.JdbcUtils" %>
<%@ page import="java.sql.ResultSet" %>
<%@ page import="java.util.Map" %>
<%@ page import="java.util.List" %>
<html>
<head>
    <title>quartz 信息</title>
</head>
<body>
<%
    List<Map<String, String>> triggerInfos = JdbcUtils.query("SELECT * FROM QUARTZ1.QRTZ_TRIGGERS");
    out.println("<table>");
    out.println("<tr><td>任务名称</td>" +
            "<td>任务所属组</td>" +
            "<td>触发器名称</td>" +
            "<td>触发器所属组</td>" +
            "<td>触发器状态</td>" +
            "<td>触发器类型</td>" +
            "<td>开始时间</td>" +
            "<td>结束时间</td></tr>");
    for(Map<String, String> triggerInfo : triggerInfos){
        out.println("<tr>");
        for (Map.Entry<String, String> entry : triggerInfo.entrySet()) {
            String key = entry.getKey().toString();
            String value = entry.getValue().toString();
            out.println("<td>" + value + "</td>");
        }
        out.println("</tr>");
    }
    out.println("<table>");
%>
</body>
</html>
